# -*- coding: utf-8 -*-
"""
@Time: 2022/2/22 18:55
@Author: jins
@File: table_device_xnyz.py
@Introduction: 
"""
from common.mysqlDataOperate import OperateMysql


def insert():
    op = OperateMysql(host='117.88.45.156', user='xluser', password='Xluser12!@')
    for i in range(200295001, 200600001):
        sql = f"""insert into device_center.device_xnyz values (
        '{i}',
        '1'
        )"""
        op.batch_excute(sql)
        if i % 1000 == 0:
            op.commit()
    op.close()


if __name__ == '__main__':
    insert()
